
0. STATA version 13.1

1. FILES DESCRIPTION
_final_merge_clean.do: Takes the raw data per country and merges, deflates, expresses in the same currency and does some basic checks.
_final_mismatch.do: Replicates Tables 2-3 and A7, A8 and A9 in the paper "What Hinders Investment in the Aftermath of Financial Crises? Insolvent 
                    Firms or Illiquid Banks?"


2. COUNTRY LIST
1 Argentina
2 Brazil
3 Chile
4 Colombia
5 Mexico
6 Peru



3. VARIABLE DESCRIPTION IN THE RAW DATA
This is the list of variables in the original raw data provided by private provider Economatica. 
Notice the dollar denominated debt and assets is not directly provided by Economatica and needs to be pulled from historical company reports to the stock market in each country. Similarly the foreign ownership variable was hand-collected by checking company hisotry, website and various
online sources. See the online Data appendix for further details.

id	        	Unique Firm Identifier
name			Name of Firm
year			Year: 1993-2007
isic_1			ISIC Classification_1Digit
isic_2			ISIC Classification_2Digit
isic_3			ISIC Classification_3Digit
ppe_net			Stock of Property, Plant and Equipment net of Depreciation and Amortization
adr_gdr			Dummy=1 since the year the firm issues an ADR in international stock markets
ext_bond_issuance	Dummy=1 if that year the firm issued a bond in international markets
ext_loan_issuance	Dummy=1 if that year the firm took a syndicated loan in international markets
int_access		Dummy=1 since the year the firm access international capital markets by issuing
totasst			Total Assets
totdolliab		Total Dollar Liabilities
totdolasst		Total Dollar Assets
totliab	double		Total Liabilities
tradable		Dummy=1 if Firm is in Tradable Sector
shortliab		Total Current Liabilities
longliab		Total Long Term Liabilities
shortdolliab		Short Term Dollar Liabilities
longdolliab		Long Term Dollar Liabilities
shortasst		Total Current Assets
longasst		Total Long Term Assets
longdolasst		Long Term Dollar Assets
shortdolasst		Short Term Dollar Assets
exports 		Total Exports
sales			Total Operational Income
country_code		Country Code
ticker			Stock market ticker
age			Age of the firm in years
publicstatus    	Public Status
cashstitotalasetss	(Cash+STI)/Total Assets 
stbankdebttotdebt	ST Bank Debt /Tot Liab (ST: short-term)
ltbankdebttotdebt	LT Bank Debt /Tot Liab (LT: long-term)
capex			Annual Investiment Expenditures

We hand-collected data on foreign ownership by checking the company history, website, and various sources as described in the data appendix
for			Percentage of direct foreign ownership
forult			Percentage of ultimate foreign ownership	               

We use data from IFS to deflate and convert to dollars of 2000.               
ER        		End of year nominal exchange rate			               
CPI      		CPI base year 2000	               



3. VARIABLE DESCRIPTION IN THE FINAL DATA (VARIABLES USED IN THE REGRESSION ANALYSIS)
DD			total dollar debt over total debt
shDD			short dollar debt over total debt
shDshD			short dollar debt over short debt
DA			total dollar assets over total assets
lonDD			long-term dollar debt over total dollar debt
lonDlonD		long-term dollar debt overt total long term debt
DA			total dollar assets over total assets
ltbankdebttotliab	long-term bank debt to total liabilities
stbankdebttotliab	short-term bank debt to total liabilities
cashstitotalassets	cash holdings to total assets
bankdebt		total bank debt:long plus short
lagTOTdebt		total liabilities in t-1
leverage		total liabilities (t-1) to total assets (t-1)
shortlev		Current liabities to current assets
bond                    ext_bond_issuance (t-1)
loan                    ext_loan_issuance (t-1)
equity                  ext_equity_issuance (t-1)





